package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the MM_PURCHASE_REQUESTS database table.
 * 
 */
@Entity
@Table(name="MM_PURCHASE_REQUESTS")
@NamedQueries({
    @NamedQuery(name = "MmPurchaseRequest.findAll", query = " SELECT c FROM MmPurchaseRequest c "),
    @NamedQuery(name = "MmPurchaseRequest.findByInstanceNo", query = " SELECT c FROM MmPurchaseRequest c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.company,c.project,c.documentNo,c.prStatus,c.lineSeqNo asc"),
    @NamedQuery(name = "MmPurchaseRequest.findByInstanceNo1", query = " SELECT c FROM MmPurchaseRequest c WHERE c.instanceNo = :instanceNo order by c.company,c.project,c.documentNo,c.prStatus,c.lineSeqNo asc"),
    @NamedQuery(name = "MmPurchaseRequest.findById", query = " SELECT c FROM MmPurchaseRequest c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "MmPurchaseRequest.findAllIsSync", query = " SELECT c FROM MmPurchaseRequest c WHERE c.issync = :issync order by c.instanceNo asc")
    })
public class MmPurchaseRequest extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;

	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_BY")
	private String actionBy;

	@Column(name="ACTION_DATE")
	private String actionDate;

	private String company;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	private String currency;

	@Column(name="DEPARTMENT_CODE")
	private String departmentCode;

	@Column(name="DOCUMENT_NO")
	private String documentNo;

	@Column(name="EBAN_EKGRP")
	private String ebanEkgrp;

	@Column(name="EBAN_EKORG")
	private String ebanEkorg;

	@Column(name="EBAN_EMLIF")
	private String ebanEmlif;

	@Column(name="EBAN_FRGDT")
	private String ebanFrgdt;

	@Column(name="EBAN_LGORT")
	private String ebanLgort;

	@Column(name="EBAN_PREIS")
	private String ebanPreis;

	@Column(name="EBKN_ANLN1")
	private String ebknAnln1;

	@Column(name="EBKN_KOSTL")
	private String ebknKostl;

	@Column(name="EBKN_PS_PSP_PNR")
	private String ebknPsPspPnr;

	@Column(name="EBKN_SAKTO")
	private String ebknSakto;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String issync;

	@Column(name="ITEM_CODE")
	private String itemCode;

	@Column(name="ITEM_DESC")
	private String itemDesc;

	@Column(name="ITEM_QTY")
	private BigDecimal itemQty;

	@Column(name="ITEM_UM")
	private String itemUm;

	@Column(name="LINE_SEQ_NO")
	private String lineSeqNo;

	@Column(name="MODEL_CODE")
	private String modelCode;
	
	@Column(name="MODEL_NAME")
	private String modelName;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	private String objective;

	private String plifz;

	@Column(name="POR_DATE")
	private String porDate;

	@Column(name="POR_TYPE")
	private String porType;

	@Column(name="PR_STATUS")
	private String prStatus;

	private String project;

	@Column(name="PURCH_TYP")
	private String purchTyp;

	private String remarks;

	@Column(name="REQUEST_PERSON")
	private String requestPerson;

	@Column(name="REQUEST_PERSON_TEL")
	private String requestPersonTel;

	@Column(name="REQUIRED_BY_DATE")
	private String requiredByDate;

	@Column(name="MODEL_REVISION")
	private String modelRevision;
	
	@Column(name="MODEL_SUB_REVISION")
	private String modelSubRevision;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TYPE_OF_PURCHASE")
	private String typeOfPurchase;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;
	
	@Column(length=1)
	private String isactive;

	private String webaz;	
	
	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;
	
	@Column(name="BUILDING_CODE")
	private String buildingCode;
	
	@Column(name="STATUS")
	private String status;
	
	@Column(name="INTERFACE_NO")
	private String interfaceNo;
	
	@Column(name="UNIT_TYPE")
	private String unitType;
	
	@Column(name="ACTIVITY_GROUP_CODE")
	private String activityGroupCode;
	
	@Column(name="PMS_TYPE_OF_PURCHASE")
	private String pmsTypeOfPurchase;
	
	@Column(name="PROPERTY_CATEGORY")
	private String propertyCategoty;
	
	
    /**
	 * @return the propertyCategoty
	 */
	public String getPropertyCategoty() {
		return propertyCategoty;
	}

	/**
	 * @param propertyCategoty the propertyCategoty to set
	 */
	public void setPropertyCategoty(String propertyCategoty) {
		this.propertyCategoty = propertyCategoty;
	}

	/**
	 * @return the pmsTypeOfPurchase
	 */
	public String getPmsTypeOfPurchase() {
		return pmsTypeOfPurchase;
	}

	/**
	 * @param pmsTypeOfPurchase the pmsTypeOfPurchase to set
	 */
	public void setPmsTypeOfPurchase(String pmsTypeOfPurchase) {
		this.pmsTypeOfPurchase = pmsTypeOfPurchase;
	}

	/**
	 * @return the activityGroupCode
	 */
	public String getActivityGroupCode() {
		return activityGroupCode;
	}

	/**
	 * @param activityGroupCode the activityGroupCode to set
	 */
	public void setActivityGroupCode(String activityGroupCode) {
		this.activityGroupCode = activityGroupCode;
	}

	/**
	 * @return the unitType
	 */
	public String getUnitType() {
		return unitType;
	}

	/**
	 * @param unitType the unitType to set
	 */
	public void setUnitType(String unitType) {
		this.unitType = unitType;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the buildingCode
	 */
	public String getBuildingCode() {
		return buildingCode;
	}

	/**
	 * @param buildingCode the buildingCode to set
	 */
	public void setBuildingCode(String buildingCode) {
		this.buildingCode = buildingCode;
	}

	/**
	 * @return the modelSubRevision
	 */
	public String getModelSubRevision() {
		return modelSubRevision;
	}

	/**
	 * @param modelSubRevision the modelSubRevision to set
	 */
	public void setModelSubRevision(String modelSubRevision) {
		this.modelSubRevision = modelSubRevision;
	}

	/**
	 * @return the modelName
	 */
	public String getModelName() {
		return modelName;
	}

	/**
	 * @param modelName the modelName to set
	 */
	public void setModelName(String modelName) {
		this.modelName = modelName;
	}
	
	public MmPurchaseRequest() {
    }
    
	/**
	 * @return the sapCompanyCode
	 */
	public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	/**
	 * @param sapCompanyCode the sapCompanyCode to set
	 */
	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	/**
	 * @return the sapPlantCode
	 */
	public String getSapPlantCode() {
		return sapPlantCode;
	}

	/**
	 * @param sapPlantCode the sapPlantCode to set
	 */
	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	/**
	 * @return the isactive
	 */
	public String getIsactive() {
		return isactive;
	}

	/**
	 * @param isactive the isactive to set
	 */
	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
		super.setPromisStagingId(promisStagingId);
	}

	public String getActionBy() {
		return this.actionBy;
	}

	public void setActionBy(String actionBy) {
		this.actionBy = actionBy;
	}

	public String getActionDate() {
		return this.actionDate;
	}

	public void setActionDate(String actionDate) {
		this.actionDate = actionDate;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getDepartmentCode() {
		return this.departmentCode;
	}

	public void setDepartmentCode(String departmentCode) {
		this.departmentCode = departmentCode;
	}

	public String getDocumentNo() {
		return this.documentNo;
	}

	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	public String getEbanEkgrp() {
		return this.ebanEkgrp;
	}

	public void setEbanEkgrp(String ebanEkgrp) {
		this.ebanEkgrp = ebanEkgrp;
	}

	public String getEbanEkorg() {
		return this.ebanEkorg;
	}

	public void setEbanEkorg(String ebanEkorg) {
		this.ebanEkorg = ebanEkorg;
	}

	public String getEbanEmlif() {
		return this.ebanEmlif;
	}

	public void setEbanEmlif(String ebanEmlif) {
		this.ebanEmlif = ebanEmlif;
	}

	public String getEbanFrgdt() {
		return this.ebanFrgdt;
	}

	public void setEbanFrgdt(String ebanFrgdt) {
		this.ebanFrgdt = ebanFrgdt;
	}

	public String getEbanLgort() {
		return this.ebanLgort;
	}

	public void setEbanLgort(String ebanLgort) {
		this.ebanLgort = ebanLgort;
	}

	public String getEbanPreis() {
		return this.ebanPreis;
	}

	public void setEbanPreis(String ebanPreis) {
		this.ebanPreis = ebanPreis;
	}

	public String getEbknAnln1() {
		return this.ebknAnln1;
	}

	public void setEbknAnln1(String ebknAnln1) {
		this.ebknAnln1 = ebknAnln1;
	}

	public String getEbknKostl() {
		return this.ebknKostl;
	}

	public void setEbknKostl(String ebknKostl) {
		this.ebknKostl = ebknKostl;
	}

	public String getEbknPsPspPnr() {
		return this.ebknPsPspPnr;
	}

	public void setEbknPsPspPnr(String ebknPsPspPnr) {
		this.ebknPsPspPnr = ebknPsPspPnr;
	}

	public String getEbknSakto() {
		return this.ebknSakto;
	}

	public void setEbknSakto(String ebknSakto) {
		this.ebknSakto = ebknSakto;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
		super.setInstanceNo(instanceNo);
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getItemCode() {
		return this.itemCode;
	}

	public void setItemCode(String itemCode) {
		this.itemCode = itemCode;
	}

	public String getItemDesc() {
		return this.itemDesc;
	}

	public void setItemDesc(String itemDesc) {
		this.itemDesc = itemDesc;
	}

	public BigDecimal getItemQty() {
		return this.itemQty;
	}

	public void setItemQty(BigDecimal itemQty) {
		this.itemQty = itemQty;
	}

	public String getItemUm() {
		return this.itemUm;
	}

	public void setItemUm(String itemUm) {
		this.itemUm = itemUm;
	}

	public String getLineSeqNo() {
		return this.lineSeqNo;
	}

	public void setLineSeqNo(String lineSeqNo) {
		this.lineSeqNo = lineSeqNo;
	}

	public String getModelCode() {
		return this.modelCode;
	}

	public void setModelCode(String modelCode) {
		this.modelCode = modelCode;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getObjective() {
		return this.objective;
	}

	public void setObjective(String objective) {
		this.objective = objective;
	}

	public String getPlifz() {
		return this.plifz;
	}

	public void setPlifz(String plifz) {
		this.plifz = plifz;
	}

	public String getPorDate() {
		return this.porDate;
	}

	public void setPorDate(String porDate) {
		this.porDate = porDate;
	}

	public String getPorType() {
		return this.porType;
	}

	public void setPorType(String porType) {
		this.porType = porType;
	}

	public String getPrStatus() {
		return this.prStatus;
	}

	public void setPrStatus(String prStatus) {
		this.prStatus = prStatus;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getPurchTyp() {
		return this.purchTyp;
	}

	public void setPurchTyp(String purchTyp) {
		this.purchTyp = purchTyp;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public String getRequestPerson() {
		return this.requestPerson;
	}

	public void setRequestPerson(String requestPerson) {
		this.requestPerson = requestPerson;
	}

	public String getRequestPersonTel() {
		return this.requestPersonTel;
	}

	public void setRequestPersonTel(String requestPersonTel) {
		this.requestPersonTel = requestPersonTel;
	}

	public String getRequiredByDate() {
		return this.requiredByDate;
	}

	public void setRequiredByDate(String requiredByDate) {
		this.requiredByDate = requiredByDate;
	}
	
	

	/**
	 * @return the modelRevision
	 */
	public String getModelRevision() {
		return modelRevision;
	}

	/**
	 * @param modelRevision the modelRevision to set
	 */
	public void setModelRevision(String modelRevision) {
		this.modelRevision = modelRevision;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTypeOfPurchase() {
		return this.typeOfPurchase;
	}

	public void setTypeOfPurchase(String typeOfPurchase) {
		this.typeOfPurchase = typeOfPurchase;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getWebaz() {
		return this.webaz;
	}

	public void setWebaz(String webaz) {
		this.webaz = webaz;
	}

}